The fields on the right-hand side in the “Event” view are used to specify which cell the event should be linked to. These fields are only relevant for the event types “Set data” and “Get data”.
In the “Doc.” field you enter the name of the document where the spreadsheet of interest is stored. This document should always be open when you run a simulation. If you leave this field blank, MS Excel 4 will assume that the spreadsheet is located in the document you opened first in the current MS Excel 4 session. Thus, unless you always open just one MS Excel 4 document at the time, you should enter a document name in the “Doc.” field.
Finally in the “Row” and “Cell” fields you enter respectively the row and column number of the cell you want to link to.
Alternatively you can enter the cell address in the following form:
R1C1
If you choose this form, you should leave the “Row” field blank. In fact if you fail to do so, DynRisk will delete the contents of this field.
If you have used the “Define name…” command in MS Excel 4 to give a name to the cell you want to link to, you have a third option: Enter the cell's name into the “Cell” field, and leave the “Row” field blank. This is option is very convenient if you later add rows or columns to your spreadsheet, and hence change the absolute address of some of the cells.
